/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2012                    */
/* Created on:     2017/8/19 9:12:12                            */
/*==============================================================*/
use ocss
go

if exists (select 1
            from  sysobjects
           where  id = object_id('tbl_Rank')
            and   type = 'U')
   drop table tbl_Rank
go

/*==============================================================*/
/* Table: tbl_Rank                                              */
/*==============================================================*/
create table tbl_Rank (
   Code                 varchar(10)          not null,
   Name                 varchar(50)          null,
   Shorthand            varchar(50)          null,
   CurDate              datetime             null,
   NetAssetValue        decimal(10,4)        null,
   AccumulatedNet       decimal(10,4)        null,
   DailyGrowth          decimal(10,4)        null,
   LastWeek             decimal(10,4)        null,
   LastMonth            decimal(10,4)        null,
   Last3Month           decimal(10,4)        null,
   Last6Month           decimal(10,4)        null,
   LastYear             decimal(10,4)        null,
   Last2Year            decimal(10,4)        null,
   Last3Year            decimal(10,4)        null,
   ThisYear             decimal(10,4)        null,
   SinceBuilt           decimal(10,4)        null,
   Custom               varchar(20)          null,
   BuiltDate            varchar(20)          null,
   Poundage             varchar(20)          null,
   PoundageCount        varchar(20)          null,
   constraint PK_TBL_RANK primary key (Code)
)
go

